package com.ttg.model.dto;

import cn.afterturn.easypoi.excel.annotation.Excel;
import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableField;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;
import lombok.Data;

import java.io.Serializable;
import java.math.BigDecimal;
import java.time.LocalDateTime;

@Data
public class PrivatePrimitiveExcelDto implements Serializable {


    private static final long serialVersionUID = -7369766511154457587L;
    @Excel(name = "银行卡号")
    private String bankCardNumber;


    @Excel(name = "卡类型")
    private Integer cardType;


    @Excel(name = "卡类别")
    private Integer cardCategory;


    @Excel(name = "卡状态")
    private Integer cardStatus;


    @Excel(name = "卡bin")
    private String cardBin;


    @Excel(name = "开户时间")
    private LocalDateTime accountOpeningTime;


    @Excel(name = "开户人姓名")
    private String accountOpeningName;


    @Excel(name = "身份证号")
    private String idNumber;


    @Excel(name = "预留手机号码")
    private String phone;


    @Excel(name = "年龄")
    private Integer age;


    @Excel(name = "性别")
    private Integer sex;


    @Excel(name = "开户行")
    private String openingBank;


    @Excel(name = "所属地区")
    private String address;


    @Excel(name = "客户经理")
    private String customerManagerName;


    @Excel(name = "客户经理ID")
    private String customerManagerId;


    @Excel(name = "管控人")
    private String controlPersonnel;


    @Excel(name = "手机银行用户")
    private Integer isPhoneBank;


    @Excel(name = "手机银行注册时间")
    private LocalDateTime phoneBankRegisterTime;


    @Excel(name = "信用卡额度")
    private BigDecimal creditCardQuota;


    @Excel(name = "客户号")
    private Integer cstId;


    @Excel(name = "当日消费金额")
    private BigDecimal dayConsumptionAmount;


    @Excel(name = "当周消费金额")
    private BigDecimal weeksConsumptionAmount;


    @Excel(name = "当月消费金额")
    private BigDecimal monthConsumptionAmount;


    @Excel(name = "当季消费金额")
    private BigDecimal quarterConsumptionAmount;


    @Excel(name = "当年消费金额")
    private BigDecimal yearConsumptionAmount;


    @Excel(name = "当日消费笔数")
    private Integer dayConsumptionStrokeCount;


    @Excel(name = "当周消费笔数")
    private Integer weeksConsumptionStrokeCount;


    @Excel(name = "当月消费笔数 ")
    private Integer monthConsumptionStrokeCount;


    @Excel(name = "当季消费笔数")
    private Integer quarterConsumptionStrokeCount;


    @Excel(name = "当年消费笔数")
    private Integer yearConsumptionStrokeCount;


    @Excel(name = "时点余额")
    private BigDecimal amount;


    @Excel(name = "月均存款")
    private BigDecimal monthlyAmount;


    @Excel(name = "季均存款")
    private BigDecimal quartertlyAmount;


    @Excel(name = "年均存款")
    private BigDecimal yearAmount;


    @Excel(name = "代发客户 0否 1是")
    private Integer commissionClient;


    @Excel(name = "收单商户 0否 1是")
    private Integer acquiringMerchant;


    @Excel(name = "当日交易金额")
    private BigDecimal dayTransactionAmount;


    @Excel(name = "当周交易金额")
    private BigDecimal weeksTransactionAmount;


    @Excel(name = "当月交易金额")
    private BigDecimal monthTransactionAmount;


    @Excel(name = "当季交易金额")
    private BigDecimal quarterTransactionAmount;


    @Excel(name = "当年交易金额")
    private BigDecimal yearTransactionAmount;


    @Excel(name = "当日交易笔数")
    private Integer dayTransactionStrokeCount;


    @Excel(name = "当周交易笔数")
    private Integer weeksTransactionStrokeCount;


    @Excel(name = "当月交易笔数")
    private Integer monthTransactionStrokeCount;


    @Excel(name = "当季交易笔数")
    private Integer quarterTransactionStrokeCount;


    @Excel(name = "当年交易笔数")
    private Integer yearTransactionStrokeCount;


    @Excel(name = "商户手续费金额")
    private BigDecimal merchantCommissionAmount;


    @Excel(name = "商户当周手续费金额")
    private BigDecimal weeksMerchantCommissionAmount;


    @Excel(name = "商户当月手续费金额")
    private BigDecimal monthMerchantCommissionAmount;


    @Excel(name = "商户当季手续费金额")
    private BigDecimal quarterMerchantCommissionAmount;


    @Excel(name = "商户当年手续费金额")
    private BigDecimal yearMerchantCommissionAmount;


    @Excel(name = "商户当日补贴费金额")
    private BigDecimal dayMerchantSubsidyAmount;


    @Excel(name = "商户当周补贴费金额")
    private BigDecimal weeksMerchantSubsidyAmount;


    @Excel(name = "商户当月补贴费金额")
    private BigDecimal monthMerchantSubsidyAmount;


    @Excel(name = "商户当季补贴费金额")
    private BigDecimal quarterMerchantSubsidyAmount;


    @Excel(name = "商户当年补贴费金额")
    private BigDecimal yearMerchantSubsidyAmount;


    @Excel(name = "贷款客户")
    private Integer loanCustomer;


    @Excel(name = "贷款授信额度")
    private BigDecimal loanQuota;


    @Excel(name = "贷款金额")
    private BigDecimal loanAmount;


    @Excel(name = "理财客户")
    private Integer financingCustomer;


    @Excel(name = "理财购买金额")
    private BigDecimal financingPurchaseAmount;


    @Excel(name = "理财持仓金额")
    private BigDecimal financingPositionAmount;


    @Excel(name = "基金客户")
    private Integer fundCustomer;


    @Excel(name = "基金购买金额")
    private BigDecimal fundPurchaseAmount;


    @Excel(name = "基金持仓金额 ")
    private BigDecimal fundPositionAmount;


    @Excel(name = "保险客户")
    private Integer insureCustomer;


    @Excel(name = "保险购买金额")
    private BigDecimal insurePurchaseAmount;


    @Excel(name = "更新时间")
    private LocalDateTime updateTime;

}

